﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_AUDIT_INSERT')
	BEGIN
		DROP  Procedure  P_AUDIT_INSERT
	END

GO

CREATE Procedure P_AUDIT_INSERT
	(
		@p_transaction_id	VARCHAR(50),
		@p_operation		NVARCHAR(256),
		@p_operator			VARCHAR(50)
	)
AS


INSERT INTO [T_AUDIT]
           ([TRANSACTION_ID]
           ,[OPERATION]
           ,[OPERATOR]
           ,[OPERATION_TIME])
     VALUES
           (@p_transaction_id
           ,@p_operation
           ,@p_operator
           ,GETDATE())

